/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 50732
 Source Host           : dev:3306
 Source Schema         : jwpj

 Target Server Type    : MySQL
 Target Server Version : 50732
 File Encoding         : 65001

 Date: 12/05/2022 19:20:53
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for course
-- ----------------------------
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(20) DEFAULT NULL COMMENT '课程名',
  `teacher_id` bigint(20) DEFAULT NULL COMMENT '老师id',
  `introduction` varchar(255) DEFAULT NULL COMMENT '课程介绍',
  `major` varchar(20) DEFAULT NULL COMMENT '专业',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='课程';

-- ----------------------------
-- Records of course
-- ----------------------------
BEGIN;
INSERT INTO `course` (`id`, `name`, `teacher_id`, `introduction`, `major`) VALUES (1, '1231', 30, '123', '软件工程');
INSERT INTO `course` (`id`, `name`, `teacher_id`, `introduction`, `major`) VALUES (2, '123', 30, '213', '网络工程');
INSERT INTO `course` (`id`, `name`, `teacher_id`, `introduction`, `major`) VALUES (3, 'qweq', 30, 'qwe', '网络工程');
COMMIT;

-- ----------------------------
-- Table structure for course_order
-- ----------------------------
DROP TABLE IF EXISTS `course_order`;
CREATE TABLE `course_order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `student_id` bigint(20) DEFAULT NULL COMMENT '学生id',
  `course_id` bigint(20) DEFAULT NULL COMMENT '课程id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='课程订阅';

-- ----------------------------
-- Records of course_order
-- ----------------------------
BEGIN;
INSERT INTO `course_order` (`id`, `student_id`, `course_id`) VALUES (7, 30, 2);
INSERT INTO `course_order` (`id`, `student_id`, `course_id`) VALUES (8, 30, 3);
COMMIT;

-- ----------------------------
-- Table structure for evaluate
-- ----------------------------
DROP TABLE IF EXISTS `evaluate`;
CREATE TABLE `evaluate` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `course_id` bigint(20) DEFAULT NULL COMMENT '课程id',
  `student_id` bigint(20) DEFAULT NULL COMMENT '学生Id',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='评价';

-- ----------------------------
-- Records of evaluate
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for evaluation_plan
-- ----------------------------
DROP TABLE IF EXISTS `evaluation_plan`;
CREATE TABLE `evaluation_plan` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='评价计划';

-- ----------------------------
-- Records of evaluation_plan
-- ----------------------------
BEGIN;
INSERT INTO `evaluation_plan` (`id`, `title`, `create_time`, `update_time`, `status`) VALUES (8, '2020学年度', '2022-04-04 07:04:11', '2022-04-04 07:04:11', 1);
COMMIT;

-- ----------------------------
-- Table structure for evaluation_status
-- ----------------------------
DROP TABLE IF EXISTS `evaluation_status`;
CREATE TABLE `evaluation_status` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  `status` int(11) DEFAULT NULL COMMENT '状态',
  `course_id` bigint(20) DEFAULT NULL COMMENT '课程id',
  `plan_id` bigint(20) DEFAULT NULL COMMENT '评价计划id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='评价状态表';

-- ----------------------------
-- Records of evaluation_status
-- ----------------------------
BEGIN;
INSERT INTO `evaluation_status` (`id`, `user_id`, `status`, `course_id`, `plan_id`) VALUES (23, 30, 1, 1, 8);
COMMIT;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(20) DEFAULT NULL COMMENT '菜单名',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父菜单id',
  `url` varchar(255) DEFAULT NULL COMMENT '菜单url',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of menu
-- ----------------------------
BEGIN;
INSERT INTO `menu` (`id`, `name`, `parent_id`, `url`, `create_time`, `update_time`) VALUES (6, '教学平台', -1, NULL, NULL, NULL);
INSERT INTO `menu` (`id`, `name`, `parent_id`, `url`, `create_time`, `update_time`) VALUES (7, '题目管理', 6, '/index/topic', NULL, '2022-03-15 03:06:39');
INSERT INTO `menu` (`id`, `name`, `parent_id`, `url`, `create_time`, `update_time`) VALUES (8, '课程管理', 6, '/index/course', NULL, NULL);
INSERT INTO `menu` (`id`, `name`, `parent_id`, `url`, `create_time`, `update_time`) VALUES (18, '学习天地', -1, '', '2022-03-15 03:02:00', '2022-03-15 03:02:00');
INSERT INTO `menu` (`id`, `name`, `parent_id`, `url`, `create_time`, `update_time`) VALUES (19, '课程订阅', -1, '/index/course/subscribe', '2022-03-15 03:03:54', NULL);
INSERT INTO `menu` (`id`, `name`, `parent_id`, `url`, `create_time`, `update_time`) VALUES (22, '课程管理', 1, '/index/course', '2022-03-26 07:45:08', NULL);
COMMIT;

-- ----------------------------
-- Table structure for menu_role
-- ----------------------------
DROP TABLE IF EXISTS `menu_role`;
CREATE TABLE `menu_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单id',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1510516672535031810 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of menu_role
-- ----------------------------
BEGIN;
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (46, 2, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (47, 2, 2);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (52, 6, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (53, 6, 2);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (54, 7, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (55, 7, 2);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (58, 4, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (59, 4, 2);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (60, 17, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (61, 17, 2);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (62, 10, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (63, 10, 2);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (64, 9, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (65, 9, 2);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (67, 2, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (69, 4, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (70, 6, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (71, 7, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (73, 9, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (74, 10, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (75, 17, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (77, 2, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (79, 4, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (80, 6, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (81, 7, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (83, 9, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (84, 10, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (85, 17, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (87, 2, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (88, 3, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (89, 4, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (90, 6, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (91, 7, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (93, 9, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (94, 10, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (95, 17, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (97, 2, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (98, 3, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (99, 4, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (100, 6, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (101, 7, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (103, 9, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (104, 10, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (105, 17, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (106, 18, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (108, 20, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (109, 21, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (113, 24, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (114, 24, 2);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (115, 24, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (116, 25, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (117, 25, 2);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (118, 25, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (119, 26, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (120, 26, 2);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (121, 26, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (122, 27, 2);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (1508985587145678849, 8, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (1508985587170844673, 8, 2);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (1508985587175038977, 8, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (1508986259257729026, 19, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (1508986259266117634, 19, 2);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (1508986259274506242, 19, 3);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (1510516672459534337, 52, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (1510516672472117249, 54, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (1510516672476311553, 70, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (1510516672484700161, 71, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (1510516672484700162, 80, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (1510516672493088770, 81, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (1510516672493088771, 100, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (1510516672497283074, 101, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (1510516672505671681, 106, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (1510516672509865986, 1508985587145678800, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (1510516672518254594, 1508986259257729000, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (1510516672522448897, 6, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (1510516672526643202, 7, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (1510516672530837505, 8, 1);
INSERT INTO `menu_role` (`id`, `menu_id`, `role_id`) VALUES (1510516672535031809, 18, 1);
COMMIT;

-- ----------------------------
-- Table structure for plan_topic
-- ----------------------------
DROP TABLE IF EXISTS `plan_topic`;
CREATE TABLE `plan_topic` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `plan_id` bigint(20) DEFAULT NULL COMMENT '评价任务Id',
  `topic_id` bigint(20) DEFAULT NULL COMMENT '题目id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='计划题目关联表';

-- ----------------------------
-- Records of plan_topic
-- ----------------------------
BEGIN;
INSERT INTO `plan_topic` (`id`, `plan_id`, `topic_id`) VALUES (16, 8, 1);
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(20) NOT NULL COMMENT '名字',
  `role_key` varchar(10) DEFAULT NULL COMMENT '角色key',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `teacher_id` bigint(20) DEFAULT NULL COMMENT '老师id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='角色';

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` (`id`, `name`, `role_key`, `update_time`, `create_time`, `teacher_id`) VALUES (1, '学生', 'student', '2022-02-26 14:22:40', '2022-02-26 14:22:42', NULL);
INSERT INTO `role` (`id`, `name`, `role_key`, `update_time`, `create_time`, `teacher_id`) VALUES (2, '老师', 'teacher', '2022-02-26 14:23:22', '2022-02-26 14:23:24', NULL);
INSERT INTO `role` (`id`, `name`, `role_key`, `update_time`, `create_time`, `teacher_id`) VALUES (3, '管理员', 'admin', NULL, '2022-03-12 16:57:51', NULL);
COMMIT;

-- ----------------------------
-- Table structure for student_evaluate
-- ----------------------------
DROP TABLE IF EXISTS `student_evaluate`;
CREATE TABLE `student_evaluate` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `course_id` bigint(20) DEFAULT NULL COMMENT '课程id',
  `student_id` bigint(20) DEFAULT NULL COMMENT '学生Id',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `topic_id` bigint(20) DEFAULT NULL COMMENT '计划中题目id',
  `fraction` int(11) DEFAULT NULL COMMENT '分数',
  `plan_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='评价';

-- ----------------------------
-- Records of student_evaluate
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for teacher_evaluation
-- ----------------------------
DROP TABLE IF EXISTS `teacher_evaluation`;
CREATE TABLE `teacher_evaluation` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `course_id` bigint(20) DEFAULT NULL COMMENT '课程id',
  `teacher_id` bigint(20) DEFAULT NULL COMMENT '老师id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `plan_id` bigint(20) DEFAULT NULL COMMENT '计划题目Id',
  `fraction` int(11) DEFAULT NULL COMMENT '分数',
  `topic_id` mediumtext COMMENT '问题id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='老师评价';

-- ----------------------------
-- Records of teacher_evaluation
-- ----------------------------
BEGIN;
INSERT INTO `teacher_evaluation` (`id`, `course_id`, `teacher_id`, `create_time`, `update_time`, `plan_id`, `fraction`, `topic_id`) VALUES (7, 1, 30, '2022-05-04 22:05:07', '2022-05-04 22:05:07', 8, 5, '1');
INSERT INTO `teacher_evaluation` (`id`, `course_id`, `teacher_id`, `create_time`, `update_time`, `plan_id`, `fraction`, `topic_id`) VALUES (8, 1, 30, '2022-05-04 22:05:07', '2022-05-04 22:05:07', 8, 5, '2');
INSERT INTO `teacher_evaluation` (`id`, `course_id`, `teacher_id`, `create_time`, `update_time`, `plan_id`, `fraction`, `topic_id`) VALUES (9, 1, 30, '2022-05-12 09:36:39', '2022-05-12 09:36:39', 8, 5, '1');
INSERT INTO `teacher_evaluation` (`id`, `course_id`, `teacher_id`, `create_time`, `update_time`, `plan_id`, `fraction`, `topic_id`) VALUES (10, 1, 30, '2022-05-12 09:36:39', '2022-05-12 09:36:39', 8, 3, '2');
INSERT INTO `teacher_evaluation` (`id`, `course_id`, `teacher_id`, `create_time`, `update_time`, `plan_id`, `fraction`, `topic_id`) VALUES (11, 1, 30, '2022-05-12 09:36:39', '2022-05-12 09:36:39', 8, 0, '1');
COMMIT;

-- ----------------------------
-- Table structure for topic
-- ----------------------------
DROP TABLE IF EXISTS `topic`;
CREATE TABLE `topic` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(255) DEFAULT NULL COMMENT '题目标题',
  `description` varchar(255) DEFAULT NULL COMMENT '说明',
  `type` varchar(20) DEFAULT NULL COMMENT '类型：如专业能力、工作积极',
  `next_topic_a` bigint(20) DEFAULT NULL COMMENT '优秀选项a',
  `next_topic_b` bigint(20) DEFAULT NULL COMMENT '良好选项b',
  `next_topic_c` bigint(20) DEFAULT NULL COMMENT '差选项c',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='评价题目';

-- ----------------------------
-- Records of topic
-- ----------------------------
BEGIN;
INSERT INTO `topic` (`id`, `title`, `description`, `type`, `next_topic_a`, `next_topic_b`, `next_topic_c`) VALUES (1, 'a萨瑟', '阿大使的期望', '教学能力', 2, 1, 2);
INSERT INTO `topic` (`id`, `title`, `description`, `type`, `next_topic_a`, `next_topic_b`, `next_topic_c`) VALUES (2, '1+1=？', '最近的教学表现', '教学能力', 1, 2, 1);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(40) NOT NULL COMMENT '用户名',
  `password` varchar(255) NOT NULL COMMENT '密码',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `nickname` varchar(40) DEFAULT NULL COMMENT '昵称',
  `phone_number` varchar(19) DEFAULT NULL COMMENT '手机号',
  `mail` varchar(20) DEFAULT NULL COMMENT '邮箱',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像url',
  `major` varchar(20) DEFAULT NULL COMMENT '专业',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `user_username_uindex` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`id`, `username`, `password`, `create_time`, `update_time`, `nickname`, `phone_number`, `mail`, `avatar`, `major`) VALUES (30, '2', '$2a$10$k2IfqTIz1CEnSX2J0OKHWOgllw/K3wpAOeLUBPBgWg4ap8EKGMpZS', '2022-03-06 01:42:46', '2022-03-06 01:42:49', 'test', '12', '12', NULL, '软件工程');
INSERT INTO `user` (`id`, `username`, `password`, `create_time`, `update_time`, `nickname`, `phone_number`, `mail`, `avatar`, `major`) VALUES (32, '1231231', '$2a$10$TgSPGk1Dkk4ULicui5Cgb.8UZPkDCy1WQ2Rv1f4QkMznxQNiZItdS', '2022-04-30 11:53:55', '2022-04-30 11:53:55', '123', '123', '123', '/api/download/daac1ff6-21ae-4913-81e8-4f6bee76a027封面3.jpg', '网络工程');
COMMIT;

-- ----------------------------
-- Table structure for user_role
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint(20) DEFAULT NULL COMMENT '学生id',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1520871010671284226 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of user_role
-- ----------------------------
BEGIN;
INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES (1510714412279861250, 31, NULL);
INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES (1510722441813483522, 35, 2);
INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES (1510722441821872130, 35, 1);
INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES (1510722441830260737, 35, 3);
INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES (1510722576853295106, 36, 1);
INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES (1510722576857489409, 36, 2);
INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES (1510722576861683713, 36, 3);
INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES (1510723162931748865, 37, 1);
INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES (1510723162935943170, 37, 2);
INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES (1510723162940137474, 37, 3);
INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES (1520248055473967106, 30, 1);
INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES (1520248055490744321, 30, 2);
INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES (1520248055494938625, 30, 3);
INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES (1520249291040362498, 31, 1);
INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES (1520249291048751105, 31, 2);
INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES (1520249291048751106, 31, 3);
INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES (1520871010637729794, 32, 1);
INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES (1520871010671284225, 32, 3);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
